package org.example.laboratorymanagement.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.example.laboratorymanagement.pojo.Plan;

import java.util.List;

@Mapper
public interface PlanMapper {


    void delete(List<Integer> ids);

    void update(Plan plan);

    @Insert("insert into plan(username, experiment, local, date, file) values (#{username},#{experiment},#{local},#{date},#{file})")
    void add(Plan plan);

    List<Plan> listPlans(@Param("username") String username, @Param("experiment") String experiment, @Param("local") String local, @Param("date") String date, @Param("time") String time);
}
